SyPurge_SyStudent

EntityType | Independent
Logical Entity Name | SyPurge_SyStudent
Default Table Name | SyPurge_SyStudent
Logical Only | NO
Owner | dbo
Definition |
Note |

SyPurge_SyStudent Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
SyPurge_SyStudentID |  | INTEGER | NO |
SyCampusID |  | INTEGER | NO |
CampusDescrip |  | CHAR(60) | YES |
LeadDate |  | DATETIME | YES |
SySchoolStatusID |  | INTEGER | NO |
SchoolStatusDescrip |  | CHAR(60) | YES |
DOB |  | DATETIME | YES |
AmSexID |  | INTEGER | YES |
SexDescrip |  | VARCHAR(60) | YES |
SyStudentID |  | INTEGER | NO |
LastName |  | VARCHAR(35) | YES |
FirstName |  | VARCHAR(35) | YES |
MiddleName |  | VARCHAR(100) | YES |
SSN |  | VARCHAR(16) | YES |
AmLeadSrcID |  | INTEGER | YES |
LeadSrcDescrip |  | VARCHAR(50) | YES |
AmLeadTypeID |  | INTEGER | YES |
LeadTypeDescrip |  | VARCHAR(50) | YES |
Phone |  | VARCHAR(16) | YES |
WorkPhone |  | VARCHAR(16) | YES |
OtherPhone |  | VARCHAR(16) | YES |
eMail |  | VARCHAR(50) | YES |
OthereMail |  | VARCHAR(50) | YES |
Addr1 |  | VARCHAR(255) | YES |
City |  | VARCHAR(35) | YES |
State |  | CHAR(2) | YES |
Zip |  | VARCHAR(20) | YES |
SyCountryID |  | INTEGER | YES |
CountryDescrip |  | VARCHAR(50) | YES |
StartDate |  | DATETIME | YES |
NickName |  | VARCHAR(20) | YES |
MaidenName |  | VARCHAR(20) | YES |
AmHighSchoolID |  | INTEGER | YES |
HighSchoolDescrip |  | VARCHAR(50) | YES |
HSGradDate |  | DATETIME | YES |
ArchiveDate |  | DATETIME | NO |
ArchiveSequence |  | INTEGER | NO |
UserID |  | INTEGER | NO |
ts |  | TIMESTAMP/DATE | NO |

SyPurge_SyStudent Keys

Key Name | Key Type | Keys
SyPurge_SyStudent_SyPurge_SyStudentID_U_C_IDX | PrimaryKey | SyPurge_SyStudentID
SyPurge_SyStudent_UserID_N_N_IDX | Inversion Entry | UserID

SyPurge_SyStudent Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Staff | Non-Identifying | One To Zero or More |  |  |  | UserID | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

SyPurge_SyStudent Check Constraints

Check Constraint Name | CheckConstraint

SyPurge_SyStudent Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SyPurge_SyStudent | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyPurge_SyStudent | NO |  |  |

SyPurge_SyStudent Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyPurge_SyStudent Data Movement Rules

Name | Type | Rule Text/Value